Go to the documentation of this file.
00001 using System;
00002 using System.Collections.Generic;
00003 using System.Linq;
00004 using System.Text;
00005 
00006 namespace FillCustomQueryTableCL
00007 {
00008     public class EntryFilterQuery : ConsistencyCheckQuery
00009     {
00010         private static string QueryTypeName = "Entry Filter";
00011         private static string GetParametersQuery =
00012                             "SELECT [Query Name] [Name], null TypeName, 0 [order] " +
00013                             "FROM [RAIS Field] " +
00014                             "WHERE [Query Name] like '{0}(%' " +
00015                             "UNION " +
00016                             "SELECT  " +
00017                             "    sys.parameters.name [Name], " +
00018                             "    sys.types.name TypeName, " +
00019                             "    sys.parameters.parameter_id " +
00020                             "FROM sys.parameters " +
00021                             "    LEFT JOIN sys.objects on sys.parameters.object_id=sys.objects.object_id " +
00022                             "    LEFT JOIN sys.types ON sys.parameters.user_type_id=sys.types.user_type_id " +
00023                             "WHERE sys.objects.name='{0}' " +
00024                             "ORDER by [order] ";
00025 
00026         public EntryFilterQuery(string name)
00027             : base(name, QueryTypeName, GetParametersQuery)
00028         {
00029         }
00030         protected override void PreСorrectParameters(System.Data.SqlClient.SqlDataReader reader)
00031         {
00032 
00033         }
00034         protected override void СorrectParameters()
00035         {
00036 
00037         }
00038     }
00039 }